Update table with primary keys (no joins, one or more rows)

• Acceptance criteria:
  • varchars, ints supported
  • "clean" input accepted
  • exceptions accepted if user input is bad

Update table without primary key

• Acceptance criteria:
  • warning provided if multiple rows will be updated
  • cancel function provided
  • varchars, ints supported
  • "clean" input accepted
  • exceptions accepted if user input is bad

Design just came as extension of previous update story. Only needed to send old values for WHERE clause

Update view of table with primary key

• Acceptance criteria:
  • varchars, ints supported
  • "clean" input accepted
  • exceptions accepted if user input is bad
• Issues:
  • Can we find out if there are primary keys?
  • Can we use JDBC MetaData?
  • Oracle vs. MySQL JDBC driver

Notes

There are issues with updating views of multiple tables.
The approach we think will work is to query for the view definition in vendor specific manor, (MySQL has INFORMATION_SCHEMA table, but slightly different for oracle). Allows for a mapping aliases in the view results to the select statement they map to.

E.g.:
Select C, A FROM view1;
View has columns A, B, C, D, where A maps to t1.c1, B to t1.c2, C to t2.c2, D to t2.c1
Note that the order of columns, and number is not exact from the select and view, and the view's columns could be from other views, meaning the mapping has to be semi-recursive.

Overall: View columns in the select are mapped to the real view columns, then to the table columns they come from.

Update using author provided information (column names, sql, ...)

- Note: "user provided information" will be refined during sprint. Currently considering providing a list of column names.

Notes

UI refactoring:

• Sorting columns
• In cell click for edit

TODO

*make user supplied rows uneditable
*where in callback does the old data replacement go

Update with complex datatype support

Edit

Issues:

• Updating a view without a primary key 
• Define author provided information

Use available functionality on Oracle 10g

Edit

Professor Hawker had stated there are various providers (ITS, CS dept) for oracle. Personal licenses are available. 

Potential issues are:

• Connectivity
• Syntax of queries
• Massive changes required
• JDBC support for metadata information
• Dual database support (need for abstraction)

Update view with primary key in oracle

Edit

This user story depends on getting oracle working first. We will refrain from estimation until we know how to proceed with oracle in general.

Edit

Update with any varchar string

Datatype Test Tables

Notes

• Overflow for datatype size
• Need to handle character escape on cancel
• Null input messes with WRS XML
• Can not update MySQL query with a blob or text showing
• Doing a edit, saving, then doing an edit in the same cell, then saving causes an error

Edit

Update with any number, integer, decimal

Datatype Test Tables

Edit

Update with any date or time-stamp

Edit

Only users with edit privileges can edit